package com.cloudfun.campusshare.repo.sql;

public class SqlAuthOrg {
    public final static String AUDIT_LIST = "SELECT auth_org.id,user.username as user_name,auth_org.merchant_type,auth_org.create_time,auth_org.org_name,auth_org.result as auditStatus,kjt_sub_merchant.audit_status as kjtAuditStatus,auth_org.user_id as userId FROM auth_org" +
            " LEFT JOIN kjt_sub_merchant ON auth_org.user_id=kjt_sub_merchant.user_id" +
            " LEFT JOIN user ON auth_org.user_id=user.id" +
            " WHERE 1=1";

    public final static String AUDIT_STATUS = "SELECT  kjt_sub_merchant.*  FROM auth_org" +
            " RIGHT JOIN kjt_sub_merchant ON auth_org.user_id = kjt_sub_merchant.user_id" +
            " LEFT JOIN USER ON auth_org.user_id = USER.id ";

}
